Release 10.1A: OpenEdge Development:
Internationalizing Applications

Creating an empty database in a particular code page

Here is another technique for producing an empty database in a particular code page. The technique is included here for completeness.

To create an empty database with a code page:
  1. Create an empty database, using the OpenEdge Data Dictionary utility.

  2. Within the OpenEdge distribution, select the DLC/prolang directory for the target locale.

    3. For example, the DLC/prolang/cze directory contains files used for Czech databases, while the DLC/prolang/utf directory contains files used for Unicode databases.

  3. Within the DLC/prolang directory you selected, select the collation data definition (.df) file whose name corresponds to the target locale.

    4. These .df files define database collations (as opposed to .df files that define database schemas). For example, the DLC/prolang/cze directory contains the following collation data definition files:

    • cze1250.df, associated with the CZECH collation of code page 1250.
    • cze852.df, associated with the CZECH collation of code page 852.
    • cze8859.df, associated with the CZECH collation of code page ISO8859-1.
      • Note: The DLC/prolang/utf directory contains the collation data definition files for the International Components for Unicode (ICU) collations (such as ICU-cs.df used for Czech databases).

  4. Confirm the collation name of the .df file you selected in Step 3 by viewing its contents using a text editor. Search for the COLLATION-NAME keyword. The character string that follows is the name of the .df file’s collation.

  5. Load the .df file whose collation name you confirmed in Step 4 into the empty database you created in Step 1 using the following steps:

    1. Using the Data Administration tool, choose Admin Load Data and Definitions (.df file). The Load Data Definitions dialog box appears.
    2. Enter the name of the data definition file into the Input File field, then choose OK.
      3. Note: The Data Administration tool calls .df files collation tables. The default is _tran.df, which contains the UTF-8 BASIC collation.

  6. Rebuild the database’s indexes by running the PROUTIL utility with the IDXBUILD qualifier. The syntax is:

    7. Syntax 
    proutil db-name -C idxbuild all
  -cpinternal internal-code-page
  -cpstream stream-code-page

    For the complete syntax of the PROUTIL utility, see OpenEdge Data Management: Database Administration .

The empty database is now associated with the desired code page.

Copyright © 2005 Progress Software Corporation
 www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095